{"status":"ok","count":20,"catalog":[{"product":{"product_id":"10983","dealer_id":"0","product_sku":"#576","product_hsn":"","product_name":"DM-576 CASUAL WEAR FANCY FANCY JEANS","product_seo_url":"dm-576-casual-wear-fancy-fancy-jeans","product_image":"images\/product\/2022\/09\/dm-576-casual-wear-fancy-fancy-jeans-2022-09-03_16_51_32.jpeg","product_qty":"20","catalog_pcs":"1","product_price":"599","product_sale_price":"599","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"10984","dealer_id":"0","product_sku":"#578","product_hsn":"","product_name":"DM-578 FORMAL WEAR FANCY JEANS","product_seo_url":"dm-578-formal-wear-fancy-jeans","product_image":"images\/product\/2022\/09\/dm-578-formal-wear-fancy-jeans-2022-09-03_16_55_46.jpeg","product_qty":"10","catalog_pcs":"1","product_price":"599","product_sale_price":"599","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"10985","dealer_id":"0","product_sku":"#579","product_hsn":"","product_name":"DM-579 ","product_seo_url":"dm-579","product_image":"images\/product\/2022\/09\/dm-579-2022-09-03_16_57_27.jpeg","product_qty":"8","catalog_pcs":"1","product_price":"599","product_sale_price":"599","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"10986","dealer_id":"0","product_sku":"#580","product_hsn":"","product_name":"DM-580 FORMAL WEAR FANCY JEANS","product_seo_url":"dm-580-formal-wear-fancy-jeans","product_image":"images\/product\/2022\/09\/dm-580-formal-wear-fancy-jeans-2022-09-03_17_03_23.jpeg","product_qty":"6","catalog_pcs":"1","product_price":"599","product_sale_price":"599","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"10987","dealer_id":"0","product_sku":"#581","product_hsn":"","product_name":"DM-581 FORMAL WEAR FANCY PANTS","product_seo_url":"dm-581-formal-wear-fancy-pants","product_image":"images\/product\/2022\/09\/dm-581-formal-wear-fancy-pants-2022-09-03_17_22_44.jpeg","product_qty":"1","catalog_pcs":"1","product_price":"699","product_sale_price":"699","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"10988","dealer_id":"0","product_sku":"#582","product_hsn":"","product_name":"DM-582 CASUAL WEAR FANCY PANTS","product_seo_url":"dm-582-casual-wear-fancy-pants","product_image":"images\/product\/2022\/09\/dm-582-casual-wear-fancy-pants-2022-09-03_17_25_46.jpg","product_qty":"10","catalog_pcs":"1","product_price":"599","product_sale_price":"599","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"10989","dealer_id":"0","product_sku":"#583","product_hsn":"","product_name":"DM-583 CASUAL WEAR FANCY PANTS","product_seo_url":"dm-583-casual-wear-fancy-pants","product_image":"images\/product\/2022\/09\/dm-583-casual-wear-fancy-pants-2022-09-03_17_29_20.jpg","product_qty":"8","catalog_pcs":"1","product_price":"599","product_sale_price":"599","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"","other_detail":"","single_catalog":"0","product_date":"2022-09-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"10990","dealer_id":"0","product_sku":"#584","product_hsn":"","product_name":"DM-584 CASUAL WEAR, FORMAL WEAR FANCY JEANS","product_seo_url":"dm-584-casual-wear-formal-wear-fancy-jeans","product_image":"images\/product\/2022\/09\/dm-584-casual-wear-formal-wear-fancy-jeans-2022-09-03_17_36_44.jpg","product_qty":"10","catalog_pcs":"1","product_price":"599","product_sale_price":"599","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"10991","dealer_id":"0","product_sku":"#585","product_hsn":"","product_name":"DM-585 CASUAL WEAR, FORMAL WEAR FANCY JEANS","product_seo_url":"dm-585-casual-wear-formal-wear-fancy-jeans","product_image":"images\/product\/2022\/09\/dm-585-casual-wear-formal-wear-fancy-jeans-2022-09-03_17_44_17.jpg","product_qty":"10","catalog_pcs":"1","product_price":"599","product_sale_price":"599","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"10992","dealer_id":"0","product_sku":"#586","product_hsn":"","product_name":"DM-586 CASUAL WEAR FANCY JEANS","product_seo_url":"dm-586-casual-wear-fancy-jeans","product_image":"images\/product\/2022\/09\/dm-586-casual-wear-fancy-jeans-2022-09-03_17_46_02.jpg","product_qty":"8","catalog_pcs":"1","product_price":"599","product_sale_price":"599","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"10994","dealer_id":"0","product_sku":"#590","product_hsn":"","product_name":"DM-590 FORMAL WEAR FANCY JEANS","product_seo_url":"dm-590-formal-wear-fancy-jeans","product_image":"images\/product\/2022\/09\/dm-590-formal-wear-fancy-jeans-2022-09-03_17_53_27.jpg","product_qty":"10","catalog_pcs":"1","product_price":"599","product_sale_price":"599","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-03","pre_book":"0","ribbon":""}},{"product":{"product_id":"10958","dealer_id":"0","product_sku":"#548","product_hsn":"","product_name":"DM-548 CASUAL WEAR FANCY TOP","product_seo_url":"dm-548-casual-wear-fancy-top","product_image":"images\/product\/2022\/09\/dm-548-casual-wear-fancy-top-2022-09-02_12_21_39.jpg","product_qty":"15","catalog_pcs":"1","product_price":"399","product_sale_price":"399","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-02","pre_book":"0","ribbon":""}},{"product":{"product_id":"10959","dealer_id":"0","product_sku":"#549","product_hsn":"","product_name":"DM-549 PARTY WEAR FANCY TOP","product_seo_url":"dm-549-party-wear-fancy-top","product_image":"images\/product\/2022\/09\/dm-549-party-wear-fancy-top-2022-09-02_12_28_39.jpeg","product_qty":"20","catalog_pcs":"1","product_price":"399","product_sale_price":"399","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-02","pre_book":"0","ribbon":""}},{"product":{"product_id":"10960","dealer_id":"0","product_sku":"#550","product_hsn":"","product_name":"DM-550 CASUAL WEAR, FORMAL WEAR, FANCY TOP","product_seo_url":"dm-550-casual-wear-formal-wear-fancy-top","product_image":"images\/product\/2022\/09\/dm-550-casual-wear-formal-wear-fancy-top-2022-09-02_12_43_42.jpeg","product_qty":"20","catalog_pcs":"1","product_price":"399","product_sale_price":"399","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-02","pre_book":"0","ribbon":""}},{"product":{"product_id":"10961","dealer_id":"0","product_sku":"#551","product_hsn":"","product_name":"DM-551 CASUAL WEAR FANCY T-SHIRT","product_seo_url":"dm-551-casual-wear-fancy-t-shirt","product_image":"images\/product\/2022\/09\/dm-551-casual-wear-fancy-t-shirt-2022-09-02_12_48_16.jpeg","product_qty":"15","catalog_pcs":"1","product_price":"399","product_sale_price":"399","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-02","pre_book":"0","ribbon":""}},{"product":{"product_id":"10962","dealer_id":"0","product_sku":"#552","product_hsn":"","product_name":"DM-552 CASUAL WEAR FANCY TOP","product_seo_url":"dm-552-casual-wear-fancy-top","product_image":"images\/product\/2022\/09\/dm-552-casual-wear-fancy-top-2022-09-02_12_53_34.jpeg","product_qty":"20","catalog_pcs":"1","product_price":"399","product_sale_price":"399","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-02","pre_book":"0","ribbon":""}},{"product":{"product_id":"10963","dealer_id":"0","product_sku":"#253","product_hsn":"","product_name":"DM-253 CASUAL WEAR FANCY PALAZO PANTS","product_seo_url":"dm-253-casual-wear-fancy-palazo-pants","product_image":"images\/product\/2022\/09\/dm-253-casual-wear-fancy-palazo-pants-2022-09-02_13_09_34.jpeg","product_qty":"14","catalog_pcs":"1","product_price":"599","product_sale_price":"599","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-02","pre_book":"0","ribbon":""}},{"product":{"product_id":"10964","dealer_id":"0","product_sku":"#554 ","product_hsn":"","product_name":"DM-554 PARTY WEAR FANCY SKIRT","product_seo_url":"dm-554-party-wear-fancy-skirt","product_image":"images\/product\/2022\/09\/dm-554-party-wear-fancy-skirt-2022-09-02_16_28_26.jpeg","product_qty":"15","catalog_pcs":"1","product_price":"499","product_sale_price":"499","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-02","pre_book":"0","ribbon":""}},{"product":{"product_id":"10966","dealer_id":"0","product_sku":"#556","product_hsn":"","product_name":"DM-556 CASUAL WEAR FANCY T-SHIRT","product_seo_url":"dm-556-casual-wear-fancy-t-shirt","product_image":"images\/product\/2022\/09\/dm-556-casual-wear-fancy-t-shirt-2022-09-02_17_02_03.jpeg","product_qty":"12","catalog_pcs":"1","product_price":"399","product_sale_price":"399","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-02","pre_book":"0","ribbon":""}},{"product":{"product_id":"10952","dealer_id":"0","product_sku":"#543","product_hsn":"","product_name":"DM-543 CASUAL WEAR,FORMAL WEAR FANCY T-SHIRT","product_seo_url":"dm-543-casual-wear-formal-wear-fancy-t-shirt","product_image":"images\/product\/2022\/09\/dm-543-casual-wear-formal-wear-fancy-t-shirt-2022-09-01_11_57_38.jpg","product_qty":"20","catalog_pcs":"1","product_price":"399","product_sale_price":"399","product_gst":"5","product_weight":"1","product_stitch":"Full Stitched","catalog_type":"","moq":"1","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","blouse_pcs":"","ideal_for":"","color":"","bottom":"","product_short_description":"","product_full_description":"","product_status":"Publish","product_length":"","product_meta_title":"","product_meta_keyword":"","product_meta_description":"","disable_date":"0000-00-00","upcoming":"0","product_type":"Ready to Ship","other_detail":"","single_catalog":"0","product_date":"2022-09-01","pre_book":"0","ribbon":""}}],"dsd":"select pm.* from relation_master as  rm  left join product_master as pm on pm.product_id=rm.product_id where 1=1  and pm.upcoming=0 group by rm.product_id order by pm.product_date desc  LIMIT 20, 20"}